AmCollegeTransfer 
Logical Entity Name  AmCollegeTransfer 
Default Table Name  AmCollegeTransfer 
Physical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

AmCollegeTransfer Columns 
ColumnName  Domain  Datatype  NULL  Definition 
AmCollegeTransferID(PK)    int  NO 
 
AmCollegeID(FK)    int  YES 
 
CollegeName    varchar(60)  YES 
 
CollegeCourseCode    varchar(16)  YES 
 
CollegeCourseDescrip    varchar(75)  YES 
 
CollegeCourseCredits    numeric(7, 2)  YES 
 
CompletionDate    datetime  YES 
 
SyStudentID(FK)    int  NO 
 
AmCollegeCourseID(FK)    int  YES 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
UserID(FK)    int  NO 
 
Ts    timestamp  NO 
 
Comments    varchar(3000)  YES 
 
Grade    char(8)  YES 
 
AmCollegeTransferStatusID(FK)    int  NO 
 
CreditsEarned    numeric(7, 2)  NO 
 
AdCourseID(FK)    int  YES 
 
CollegeCourseGrade    char(3)  YES 
 
DateApproved    datetime  YES 
 
AdTermID(FK)    int  YES 
 
CollegeCourseCreditsAttempt    numeric(9, 2)  YES 
 
CollegeCourseHoursAttempt    numeric(9, 2)  YES 
 
CollegeCourseGradePoints    numeric(9, 2)  YES 
 
CollegeCourseCreditsEarned    numeric(9, 2)  YES 
 
CollegeCourseHoursEarned    numeric(9, 2)  YES 
 
StartDate    datetime  YES 
 
ClockHours    numeric(9, 2)  YES 
 
HoursEarned    numeric(9, 2)  YES 
 
AmHighSchoolID(FK)    int  YES 
 
AmHighSchoolCourseID(FK)    int  YES 
 
AmTransferTypeID(FK)    int  YES 
 
TransferCreditType    bit  NO 
 
ChangedVia    nvarchar(2)  YES 
 

AmCollegeTransfer Primary and Unique Keys 
Key Name  Key Type  Keys 
AmCollegeTransfer_AmCollegeTransferID_U_C_IDX  PrimaryKey  AmCollegeTransferID 

AmCollegeTransfer Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
AdTerm  Non-Identifying  Zero or One to Zero or More  FK__AmCollege__AdTer__63DC2D9B      AdTermID  NO  YES 
AmCollege  Non-Identifying  Zero or One to Zero or More  FK_AmCollegeTransfer.AmCollegeID_AmCollege.AmCollegeID      AmCollegeID  NO  YES 
syStudent  Non-Identifying  One To Zero or More  FK_AmCollegeTransfer.SyStudentID_SyStudent.SyStudentID      SyStudentID  NO  YES 
SyStaff  Non-Identifying  One To Zero or More  FK_AmCollegeTransfer.UserID_SyStaff.SyStaffID      UserID  NO  YES 
AdCourse  Non-Identifying  Zero or One to Zero or More  FK_AmCollegeTransfer_AdCourseID_AdCourse_AdCourseID      AdCourseID  NO  YES 
AmCollegeCourse  Non-Identifying  Zero or One to Zero or More  FK_AmCollegeTransfer_AmCollegeCourseID_AmCollegeCourse_AmCollegeCourseID      AmCollegeCourseID  NO  YES 
AmCollegeTransferStatus  Non-Identifying  One To Zero or More  FK_AmCollegeTransfer_AmCollegeTransferStatusID_AmCollegeTransferStatus_AmCollegeTransferStatusID      AmCollegeTransferStatusID  NO  YES 
AmHighSchoolCourse  Non-Identifying  Zero or One to Zero or More  FK_AmCollegeTransferAmHighSchoolCourseID_AmHighSchoolCourseAmHighSchoolCourseID      AmHighSchoolCourseID  NO  YES 
AmHighSchool  Non-Identifying  Zero or One to Zero or More  FK_AmCollegeTransferAmHighSchoolID_AmHighSchoolAmHighSchoolID      AmHighSchoolID  NO  YES 
AmTransferType  Non-Identifying  Zero or One to Zero or More  FK_AmCollegeTransferAmTransferTypeID_AmTransferTypeAmTransferTypeID      AmTransferTypeID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
AdEnrollSched  Non-Identifying  One To Zero or More  FK_AdEnrollSched.AmCollegeTransferID_AmCollegeTransfer.AmCollegeTransferID        NO  YES 
AdGPAStudentCourse  Non-Identifying  One To Zero or More  FK_AdGPAStudentCourseAmCollegeTransferID_AmCollegeTransferAmCollegeTransferID        NO  YES 
AmCollegeTransferExternalCourse  Non-Identifying  One To Zero or More  FK_AmCollegeTransferExternalCourse_AmCollegeTransferID_AmCollegeTransfer_AmCollegeTransferID        NO  YES 
AmCollegeTransferInternalCourse  Non-Identifying  One To Zero or More  FK_AmCollegeTransferInternalCourse_AmCollegeTransferID_AmCollegeTransfer_AmCollegeTransferID        NO  YES 

AmCollegeTransfer Check Constraints 
Check Constraint Name  CheckConstraint 

AmCollegeTransfer Storage 
STORAGE OPTION  STORAGE VALUE 
Filegroup  PRIMARY 
Text Image File Group   

AmCollegeTransfer Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.StudentTransferCredit 
NO       
Physical (Microsoft SQL Server)
dbo.AmCollegeTransfer 
NO       

AmCollegeTransfer Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  PreviousEd_TransferCredits 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Academic Records 
Physical (Microsoft SQL Server)  Admissions 

AmCollegeTransfer Data Movement Rules 
Name  Type  Rule Text/Value